
GO
/****** Object:  Table [dbo].[SocialLog]    Script Date: 01/18/2008 16:50:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SocialLog](
	[UserID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[TimeStamp] [datetime] NOT NULL,
	[ContactsNearbyBeforeMove] [int] NOT NULL,
	[ContactsNearbyAfterMove] [int] NOT NULL,
 CONSTRAINT [PK_SocialLedger] PRIMARY KEY CLUSTERED 
(
	[UserID] ASC,
	[TimeStamp] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF